{ "cells": [ { "cell_type": "markdown", "id": "410e55ce-7c24-46bc-a6dd-5b2b39ab7e0f", "metadata": {}, "source": [ "
" ] }, { "cell_type": "markdown", "id": "8cfda4d5-2e0b-4b80-a4da-02d849db32bc", "metadata": {}, "source": [ "• O estudo centra-se na análise de um programa de descontos para produtos próximos da data de validade (etiquetas cor-de-rosa). O objetivo é compreender o impacto das reduções de preço e o momento em que foram aplicadas, identificando padrões de consumo e desenvolvendo estratégias para maximizar a eficiência do programa.\n", "\n", "• Para isso, foram recolhidos dados de vendas e produtos não vendidos de diversas lojas em Portugal Continental de produtos aos quais foram aplicados a etiqueta de desconto (etiqueta cor-de-rosa) durante o mês de Outubro de 2021. Os dados fornecidos refletem um cenário realista, mas com imperfeições típicas de um ambiente operacional. A análise desses dados permitirá definir abordagens para optimizar as decisões de pricing e minimizar desperdícios associados a produtos que atingem o limite de `shelf life`.\n", "\n", "• O estudo está estruturado em várias fases:| \n", " | idstore | \n", "type | \n", "selling_square_ft | \n", "district | \n", "
|---|---|---|---|---|
| 0 | \n", "1 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 1 | \n", "2 | \n", "Large | \n", "12358.0 | \n", "Bragança | \n", "
| 2 | \n", "3 | \n", "Large | \n", "16159.0 | \n", "Lisboa | \n", "
| 3 | \n", "4 | \n", "Large | \n", "17903.0 | \n", "Porto | \n", "
| 4 | \n", "5 | \n", "Large | \n", "16179.0 | \n", "Coimbra | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 337 | \n", "338 | \n", "Small | \n", "1935.0 | \n", "Leiria | \n", "
| 338 | \n", "339 | \n", "Small | \n", "2680.0 | \n", "Portalegre | \n", "
| 339 | \n", "340 | \n", "Small | \n", "866.0 | \n", "Coimbra | \n", "
| 340 | \n", "341 | \n", "Small | \n", "NaN | \n", "Castelo Branco | \n", "
| 341 | \n", "342 | \n", "Small | \n", "403.0 | \n", "Beja | \n", "
342 rows × 4 columns
\n", "| \n", " | idstore | \n", "sku | \n", "brand | \n", "oldpvp | \n", "new_pvp (discount) | \n", "labelqty | \n", "weight (g) | \n", "Payment_method | \n", "Margin (%) | \n", "Profit (€) | \n", "perc_expiring_sku | \n", "expiring_date | \n", "labelling_date | \n", "sell_date | \n", "sold | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.22 | \n", "2.11 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.3376 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "
| 1 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "3.96 | \n", "1.98 (0.50) | \n", "1 | \n", "260 | \n", "\n", " | 16 | \n", "0.3168 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "NaT | \n", "0.0 | \n", "
| 2 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.74 | \n", "2.37 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3792 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "1.0 | \n", "
| 3 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.2 | \n", "2.1 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.3360 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "
| 4 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.62 | \n", "2.31 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3696 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "NaN | \n", "
| 5 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.62 | \n", "2.31 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3696 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "NaN | \n", "
| 6 | \n", "1 | \n", "1 | \n", "Marca1 | \n", "3.42 | \n", "1.71 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.2736 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "
| 7 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "3.62 | \n", "1.81 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.2896 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "
| 8 | \n", "1 | \n", "1 | \n", "Marca1 | \n", "4.62 | \n", "2.31 (0.50) | \n", "1 | \n", "260 | \n", "\n", " | 16 | \n", "0.3696 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "NaT | \n", "0.0 | \n", "
| 9 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.38 | \n", "2.19 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.3504 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "
| 10 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "5.23 | \n", "NaN | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.4176 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "1.0 | \n", "
| 11 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "5.89 | \n", "2.94 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.4704 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "
| 12 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "3.78 | \n", "1.89 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3024 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "
| 13 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.76 | \n", "2.38 (0.50) | \n", "1 | \n", "260 | \n", "\n", " | 16 | \n", "0.3808 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "NaT | \n", "0.0 | \n", "
| 14 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Cash | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-14 | \n", "1.0 | \n", "
| 15 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "NaN | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Cash | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-14 | \n", "1.0 | \n", "
| 16 | \n", "2 | \n", "2 | \n", "marca2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Card | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-15 | \n", "1.0 | \n", "
| 17 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Cash | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-16 | \n", "1.0 | \n", "
| \n", " | idstore | \n", "sku | \n", "brand | \n", "oldpvp | \n", "new_pvp (discount) | \n", "labelqty | \n", "weight (g) | \n", "Payment_method | \n", "Margin (%) | \n", "Profit (€) | \n", "perc_expiring_sku | \n", "expiring_date | \n", "labelling_date | \n", "sell_date | \n", "sold | \n", "type | \n", "selling_square_ft | \n", "district | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36 | \n", "7 | \n", "2 | \n", "Marca2 | \n", "3.19 | \n", "2.39 (0.25) | \n", "1 | \n", "222 | \n", "\n", " | 15 | \n", "0.3585 | \n", "0.111111 | \n", "26/10/2021 | \n", "2021-10-15 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "13618.0 | \n", "Guarda | \n", "
| 39 | \n", "7 | \n", "2 | \n", "Marca 2 | \n", "3.19 | \n", "2.39 (0.25) | \n", "1 | \n", "222 | \n", "\n", " | 15 | \n", "0.3585 | \n", "0.111111 | \n", "26/10/2021 | \n", "2021-10-15 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "13618.0 | \n", "Guarda | \n", "
| 41 | \n", "7 | \n", "2 | \n", "Marca 2 | \n", "3.19 | \n", "2.39 (0.25) | \n", "1 | \n", "222 | \n", "\n", " | 15 | \n", "0.3585 | \n", "0.111111 | \n", "26/10/2021 | \n", "2021-10-15 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "13618.0 | \n", "Guarda | \n", "
| 42 | \n", "7 | \n", "2 | \n", "Marca 2 | \n", "3.19 | \n", "2.39 (0.25) | \n", "1 | \n", "222 | \n", "\n", " | 15 | \n", "0.3585 | \n", "0.111111 | \n", "26/10/2021 | \n", "2021-10-15 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "13618.0 | \n", "Guarda | \n", "
| 43 | \n", "7 | \n", "2 | \n", "Marca 2 | \n", "3.19 | \n", "2.39 (0.25) | \n", "1 | \n", "222 | \n", "\n", " | 15 | \n", "0.3585 | \n", "0.111111 | \n", "26/10/2021 | \n", "2021-10-15 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "13618.0 | \n", "Guarda | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 150034 | \n", "177 | \n", "318 | \n", "Marca2 | \n", "2.49 | \n", "1,24 (50%) | \n", "1 | \n", "97 | \n", "\n", " | 11 | \n", "0.1364 | \n", "0.006289 | \n", "19-10-2021 | \n", "2021-10-18 | \n", "NaT | \n", "0.0 | \n", "Small | \n", "842.0 | \n", "Porto | \n", "
| 150036 | \n", "177 | \n", "318 | \n", "Marca 2 | \n", "2.49 | \n", "1,24 (50%) | \n", "1 | \n", "97 | \n", "\n", " | 11 | \n", "0.1364 | \n", "0.006289 | \n", "19-10-2021 | \n", "2021-10-18 | \n", "NaT | \n", "0.0 | \n", "Small | \n", "842.0 | \n", "Porto | \n", "
| 150038 | \n", "177 | \n", "318 | \n", "Marca 2 | \n", "2.49 | \n", "1,24 (50%) | \n", "1 | \n", "97 | \n", "\n", " | 11 | \n", "0.1364 | \n", "0.006289 | \n", "19-10-2021 | \n", "2021-10-18 | \n", "NaT | \n", "0.0 | \n", "Small | \n", "842.0 | \n", "Porto | \n", "
| 150048 | \n", "193 | \n", "318 | \n", "Marca 2 | \n", "2.49 | \n", "1.24 (0.50) | \n", "1 | \n", "97 | \n", "Cash | \n", "11 | \n", "0.1364 | \n", "0.100629 | \n", "19-10-2021 | \n", "2021-10-03 | \n", "2021-10-09 | \n", "1.0 | \n", "Medium | \n", "5048.0 | \n", "Viseu | \n", "
| 150051 | \n", "203 | \n", "318 | \n", "Marca2 | \n", "2.49 | \n", "1.24 (0.50) | \n", "1 | \n", "97 | \n", "Cash | \n", "11 | \n", "0.1364 | \n", "0.113208 | \n", "19-10-2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Medium | \n", "9370.0 | \n", "Faro | \n", "
33740 rows × 18 columns
\n", "| \n", " | idstore | \n", "sku | \n", "brand | \n", "oldpvp | \n", "new_pvp (discount) | \n", "labelqty | \n", "weight (g) | \n", "Payment_method | \n", "Margin (%) | \n", "Profit (€) | \n", "perc_expiring_sku | \n", "expiring_date | \n", "labelling_date | \n", "sell_date | \n", "sold | \n", "type | \n", "selling_square_ft | \n", "district | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.22 | \n", "2.11 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.3376 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 1 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "3.96 | \n", "1.98 (0.50) | \n", "1 | \n", "260 | \n", "\n", " | 16 | \n", "0.3168 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 2 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.74 | \n", "2.37 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3792 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 3 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.2 | \n", "2.1 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.3360 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 4 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.62 | \n", "2.31 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3696 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "NaN | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 5 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.62 | \n", "2.31 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3696 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "NaN | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 6 | \n", "1 | \n", "1 | \n", "Marca1 | \n", "3.42 | \n", "1.71 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.2736 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 7 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "3.62 | \n", "1.81 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.2896 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 8 | \n", "1 | \n", "1 | \n", "Marca1 | \n", "4.62 | \n", "2.31 (0.50) | \n", "1 | \n", "260 | \n", "\n", " | 16 | \n", "0.3696 | \n", "0.005025 | \n", "02/10/2021 | \n", "2021-10-01 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 9 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.38 | \n", "2.19 (0.50) | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.3504 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 10 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "5.23 | \n", "NaN | \n", "1 | \n", "260 | \n", "Card | \n", "16 | \n", "0.4176 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-03 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 11 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "5.89 | \n", "2.94 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.4704 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 12 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "3.78 | \n", "1.89 (0.50) | \n", "1 | \n", "260 | \n", "Cash | \n", "16 | \n", "0.3024 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "2021-10-02 | \n", "1.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 13 | \n", "1 | \n", "1 | \n", "Marca 1 | \n", "4.76 | \n", "2.38 (0.50) | \n", "1 | \n", "260 | \n", "\n", " | 16 | \n", "0.3808 | \n", "0.010050 | \n", "03/10/2021 | \n", "2021-10-01 | \n", "NaT | \n", "0.0 | \n", "Large | \n", "4762.0 | \n", "Évora | \n", "
| 14 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Cash | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-14 | \n", "1.0 | \n", "Large | \n", "12358.0 | \n", "Bragança | \n", "
| 15 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "NaN | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Cash | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-14 | \n", "1.0 | \n", "Large | \n", "12358.0 | \n", "Bragança | \n", "
| 16 | \n", "2 | \n", "2 | \n", "marca2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Card | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-15 | \n", "1.0 | \n", "Large | \n", "12358.0 | \n", "Bragança | \n", "
| 17 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Cash | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-16 | \n", "1.0 | \n", "Large | \n", "12358.0 | \n", "Bragança | \n", "
| 18 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Cash | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-17 | \n", "1.0 | \n", "Large | \n", "12358.0 | \n", "Bragança | \n", "
| 19 | \n", "2 | \n", "2 | \n", "marca 2 | \n", "3.19 | \n", "1.59 (0.50) | \n", "1 | \n", "222 | \n", "Card | \n", "15 | \n", "0.2385 | \n", "0.121212 | \n", "25/10/2021 | \n", "2021-10-13 | \n", "2021-10-17 | \n", "1.0 | \n", "Large | \n", "12358.0 | \n", "Bragança | \n", "
| \n", " | idstore | \n", "sku | \n", "labelqty | \n", "Margin (%) | \n", "Profit (€) | \n", "perc_expiring_sku | \n", "labelling_date | \n", "sell_date | \n", "sold | \n", "selling_square_ft | \n", "
|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "150054.000000 | \n", "150054.000000 | \n", "150054.0 | \n", "150054.000000 | \n", "150054.000000 | \n", "149929.000000 | \n", "150054 | \n", "80511 | \n", "149940.000000 | \n", "139275.000000 | \n", "
| mean | \n", "139.234242 | \n", "163.699422 | \n", "1.0 | \n", "15.824950 | \n", "0.175131 | \n", "0.385245 | \n", "2021-10-16 16:41:47.577271808 | \n", "2021-10-17 18:22:01.846704384 | \n", "0.536568 | \n", "5978.197487 | \n", "
| min | \n", "1.000000 | \n", "1.000000 | \n", "1.0 | \n", "10.000000 | \n", "0.034000 | \n", "0.000000 | \n", "2021-10-01 00:00:00 | \n", "2021-10-01 00:00:00 | \n", "0.000000 | \n", "10.000000 | \n", "
| 25% | \n", "59.000000 | \n", "99.000000 | \n", "1.0 | \n", "13.000000 | \n", "0.124500 | \n", "0.200000 | \n", "2021-10-10 00:00:00 | \n", "2021-10-11 00:00:00 | \n", "0.000000 | \n", "1218.000000 | \n", "
| 50% | \n", "135.000000 | \n", "160.000000 | \n", "1.0 | \n", "17.000000 | \n", "0.152900 | \n", "0.333333 | \n", "2021-10-17 00:00:00 | \n", "2021-10-18 00:00:00 | \n", "1.000000 | \n", "4982.000000 | \n", "
| 75% | \n", "212.000000 | \n", "236.000000 | \n", "1.0 | \n", "19.000000 | \n", "0.222400 | \n", "0.666667 | \n", "2021-10-25 00:00:00 | \n", "2021-10-25 00:00:00 | \n", "1.000000 | \n", "8671.000000 | \n", "
| max | \n", "332.000000 | \n", "319.000000 | \n", "1.0 | \n", "20.000000 | \n", "99.900000 | \n", "2.000000 | \n", "2021-10-31 00:00:00 | \n", "2021-11-18 00:00:00 | \n", "1.000000 | \n", "25258.000000 | \n", "
| std | \n", "87.056044 | \n", "87.247006 | \n", "0.0 | \n", "3.303568 | \n", "0.268439 | \n", "0.223626 | \n", "NaN | \n", "NaN | \n", "0.498663 | \n", "5533.809602 | \n", "
| \n", " | brand | \n", "oldpvp | \n", "new_pvp (discount) | \n", "weight (g) | \n", "Payment_method | \n", "expiring_date | \n", "type | \n", "district | \n", "
|---|---|---|---|---|---|---|---|---|
| count | \n", "150054 | \n", "150032.00 | \n", "150026 | \n", "150050 | \n", "150054 | \n", "150054 | \n", "150054 | \n", "150054 | \n", "
| unique | \n", "328 | \n", "140.00 | \n", "396 | \n", "189 | \n", "3 | \n", "84 | \n", "4 | \n", "18 | \n", "
| top | \n", "marca 2 | \n", "1.19 | \n", "0.83 (0.30) | \n", "121 | \n", "\n", " | 28/10/2021 | \n", "Medium | \n", "Lisboa | \n", "
| freq | \n", "18249 | \n", "22234.00 | \n", "18219 | \n", "9521 | \n", "69543 | \n", "4741 | \n", "62590 | \n", "14888 | \n", "
| \n", " | new_pvp (discount) | \n", "new_pvp | \n", "discount | \n", "
|---|---|---|---|
| 0 | \n", "2.11 (0.50) | \n", "2.11 | \n", "(0.50) | \n", "
| 1 | \n", "1.98 (0.50) | \n", "1.98 | \n", "(0.50) | \n", "
| 2 | \n", "2.37 (0.50) | \n", "2.37 | \n", "(0.50) | \n", "
| 3 | \n", "2.1 (0.50) | \n", "2.1 | \n", "(0.50) | \n", "
| 4 | \n", "2.31 (0.50) | \n", "2.31 | \n", "(0.50) | \n", "
| 5 | \n", "2.31 (0.50) | \n", "2.31 | \n", "(0.50) | \n", "
| 6 | \n", "1.71 (0.50) | \n", "1.71 | \n", "(0.50) | \n", "
| 7 | \n", "1.81 (0.50) | \n", "1.81 | \n", "(0.50) | \n", "
| 8 | \n", "2.31 (0.50) | \n", "2.31 | \n", "(0.50) | \n", "
| 9 | \n", "2.19 (0.50) | \n", "2.19 | \n", "(0.50) | \n", "
| 10 | \n", "NaN | \n", "nan | \n", "NaN | \n", "
| \n", " | idstore | \n", "sku | \n", "brand | \n", "oldpvp | \n", "labelqty | \n", "weight (g) | \n", "Payment_method | \n", "Margin (%) | \n", "Profit (€) | \n", "perc_expiring_sku | \n", "expiring_date | \n", "labelling_date | \n", "sell_date | \n", "sold | \n", "type | \n", "selling_square_ft | \n", "district | \n", "new_pvp | \n", "discount | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1143 | \n", "17 | \n", "8 | \n", "MARCA2 | \n", "1.19 | \n", "1 | \n", "174.0 | \n", "Card | \n", "15 | \n", "0.1245 | \n", "0.2 | \n", "2021-10-22 | \n", "2021-10-21 | \n", "2021-10-20 | \n", "1 | \n", "Large | \n", "16732.0 | \n", "Viana do Castelo | \n", "0.83 | \n", "0.3 | \n", "
| 1144 | \n", "17 | \n", "8 | \n", "MARCA2 | \n", "1.19 | \n", "1 | \n", "174.0 | \n", "Card | \n", "15 | \n", "0.1245 | \n", "0.2 | \n", "2021-10-22 | \n", "2021-10-21 | \n", "2021-10-20 | \n", "1 | \n", "Large | \n", "16732.0 | \n", "Viana do Castelo | \n", "0.83 | \n", "0.3 | \n", "
| 1145 | \n", "17 | \n", "8 | \n", "MARCA2 | \n", "1.19 | \n", "1 | \n", "174.0 | \n", "Cash | \n", "15 | \n", "0.1245 | \n", "0.2 | \n", "2021-10-22 | \n", "2021-10-21 | \n", "2021-10-20 | \n", "1 | \n", "Large | \n", "16732.0 | \n", "Viana do Castelo | \n", "0.83 | \n", "0.3 | \n", "
| 1146 | \n", "17 | \n", "8 | \n", "MARCA2 | \n", "1.19 | \n", "1 | \n", "174.0 | \n", "Card | \n", "15 | \n", "0.1245 | \n", "0.2 | \n", "2021-10-22 | \n", "2021-10-21 | \n", "2021-10-20 | \n", "1 | \n", "Large | \n", "16732.0 | \n", "Viana do Castelo | \n", "0.83 | \n", "0.3 | \n", "
| 39214 | \n", "17 | \n", "102 | \n", "MARCA2 | \n", "0.99 | \n", "1 | \n", "188.0 | \n", "Card | \n", "12 | \n", "0.0828 | \n", "0.5 | \n", "2021-10-22 | \n", "2021-10-21 | \n", "2021-10-20 | \n", "1 | \n", "Large | \n", "16732.0 | \n", "Viana do Castelo | \n", "0.69 | \n", "0.3 | \n", "
| 39215 | \n", "17 | \n", "102 | \n", "MARCA2 | \n", "0.99 | \n", "1 | \n", "188.0 | \n", "Cash | \n", "12 | \n", "0.0828 | \n", "0.5 | \n", "2021-10-22 | \n", "2021-10-21 | \n", "2021-10-20 | \n", "1 | \n", "Large | \n", "16732.0 | \n", "Viana do Castelo | \n", "0.69 | \n", "0.3 | \n", "
| \n", " | idstore | \n", "sku | \n", "brand | \n", "oldpvp | \n", "labelqty | \n", "weight (g) | \n", "Payment_method | \n", "Margin (%) | \n", "Profit (€) | \n", "perc_expiring_sku | \n", "expiring_date | \n", "labelling_date | \n", "sell_date | \n", "sold | \n", "type | \n", "selling_square_ft | \n", "district | \n", "new_pvp | \n", "discount | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 452 | \n", "64 | \n", "4 | \n", "MARCA3 | \n", "500.0 | \n", "1 | \n", "134.0 | \n", "Card | \n", "17 | \n", "0.3315 | \n", "0.2500 | \n", "2021-10-30 | \n", "2021-10-29 | \n", "2021-10-29 | \n", "1 | \n", "Medium | \n", "7879.0 | \n", "Santarém | \n", "250.0 | \n", "0.5 | \n", "
| 50171 | \n", "289 | \n", "108 | \n", "MARCA20 | \n", "999.0 | \n", "1 | \n", "227.0 | \n", "No_Payment | \n", "20 | \n", "99.9000 | \n", "0.1013 | \n", "2021-10-10 | \n", "2021-10-02 | \n", "NaT | \n", "0 | \n", "Small | \n", "342.0 | \n", "Viana do Castelo | \n", "499.5 | \n", "0.5 | \n", "
| \n", " | idstore | \n", "sku | \n", "brand | \n", "oldpvp | \n", "labelqty | \n", "weight (g) | \n", "Payment_method | \n", "Margin (%) | \n", "Profit (€) | \n", "perc_expiring_sku | \n", "expiring_date | \n", "labelling_date | \n", "sell_date | \n", "sold | \n", "type | \n", "selling_square_ft | \n", "district | \n", "new_pvp | \n", "discount | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 550 | \n", "83 | \n", "4 | \n", "MARCA3 | \n", "2.79 | \n", "1 | \n", "134.0 | \n", "No_Payment | \n", "17 | \n", "0.3315 | \n", "0.5 | \n", "2021-10-09 | \n", "2021-10-07 | \n", "NaT | \n", "0 | \n", "Medium | \n", "4330.0 | \n", "Braga | \n", "0.0279 | \n", "0.99 | \n", "
| \n", " | F1 Train | \n", "F1 Validation | \n", "Recall Train | \n", "Recall Validation | \n", "Precision Train | \n", "Precision Validation | \n", "Accuracy Train | \n", "Accuracy Validation | \n", "Running Time | \n", "
|---|---|---|---|---|---|---|---|---|---|
| Logistic Regression | \n", "0.6236+/-0.0008 | \n", "0.6233+/-0.0044 | \n", "0.6351+/-0.0008 | \n", "0.6348+/-0.0042 | \n", "0.6387+/-0.0009 | \n", "0.6384+/-0.0047 | \n", "0.6351+/-0.0008 | \n", "0.6348+/-0.0042 | \n", "0.6674 | \n", "
| KNN | \n", "0.8123+/-0.0005 | \n", "0.7109+/-0.0036 | \n", "0.812+/-0.0005 | \n", "0.7105+/-0.0036 | \n", "0.8136+/-0.0004 | \n", "0.7128+/-0.0035 | \n", "0.812+/-0.0005 | \n", "0.7105+/-0.0036 | \n", "56.1947 | \n", "
| DT | \n", "0.7217+/-0.0017 | \n", "0.6816+/-0.0039 | \n", "0.7222+/-0.0017 | \n", "0.6821+/-0.0038 | \n", "0.7218+/-0.0017 | \n", "0.6816+/-0.0039 | \n", "0.7222+/-0.0017 | \n", "0.6821+/-0.0038 | \n", "0.4728 | \n", "
| RFC | \n", "0.8031+/-0.0006 | \n", "0.7218+/-0.0036 | \n", "0.8038+/-0.0006 | \n", "0.7228+/-0.0035 | \n", "0.8043+/-0.0006 | \n", "0.7224+/-0.0035 | \n", "0.8038+/-0.0006 | \n", "0.7228+/-0.0035 | \n", "32.7012 | \n", "
| NB | \n", "0.6153+/-0.0008 | \n", "0.6152+/-0.0048 | \n", "0.6297+/-0.0008 | \n", "0.6296+/-0.0046 | \n", "0.6347+/-0.0009 | \n", "0.6347+/-0.0054 | \n", "0.6297+/-0.0008 | \n", "0.6296+/-0.0046 | \n", "0.1547 | \n", "
| GBC | \n", "0.6487+/-0.0014 | \n", "0.6476+/-0.0046 | \n", "0.6538+/-0.0012 | \n", "0.6527+/-0.0046 | \n", "0.6542+/-0.0012 | \n", "0.6529+/-0.0049 | \n", "0.6538+/-0.0012 | \n", "0.6527+/-0.0046 | \n", "11.8024 | \n", "
| ABC | \n", "0.6646+/-0.001 | \n", "0.6615+/-0.0043 | \n", "0.6685+/-0.0009 | \n", "0.6654+/-0.0042 | \n", "0.6686+/-0.0009 | \n", "0.6655+/-0.0044 | \n", "0.6685+/-0.0009 | \n", "0.6654+/-0.0042 | \n", "13.4332 | \n", "
| SVC | \n", "0.6111+/-0.0008 | \n", "0.6111+/-0.0047 | \n", "0.628+/-0.0007 | \n", "0.628+/-0.0044 | \n", "0.635+/-0.0009 | \n", "0.635+/-0.0052 | \n", "0.628+/-0.0007 | \n", "0.628+/-0.0044 | \n", "3381.7169 | \n", "
| MLP | \n", "0.6459+/-0.0036 | \n", "0.6417+/-0.0034 | \n", "0.652+/-0.0016 | \n", "0.6478+/-0.0043 | \n", "0.6533+/-0.0023 | \n", "0.649+/-0.0057 | \n", "0.652+/-0.0016 | \n", "0.6478+/-0.0043 | \n", "643.533 | \n", "
| \n", " | F1 Train | \n", "F1 Validation | \n", "Recall Train | \n", "Recall Validation | \n", "Precision Train | \n", "Precision Validation | \n", "Accuracy Train | \n", "Accuracy Validation | \n", "Running Time | \n", "
|---|---|---|---|---|---|---|---|---|---|
| Logistic Regression | \n", "0.6129+/-0.0008 | \n", "0.6128+/-0.0046 | \n", "0.628+/-0.0008 | \n", "0.6279+/-0.0043 | \n", "0.6334+/-0.0009 | \n", "0.6333+/-0.0051 | \n", "0.628+/-0.0008 | \n", "0.6279+/-0.0043 | \n", "0.5946 | \n", "
| KNN | \n", "0.7933+/-0.0006 | \n", "0.7033+/-0.0033 | \n", "0.7931+/-0.0006 | \n", "0.703+/-0.0033 | \n", "0.7941+/-0.0005 | \n", "0.7047+/-0.0035 | \n", "0.7931+/-0.0006 | \n", "0.703+/-0.0033 | \n", "15.8553 | \n", "
| DT | \n", "0.7156+/-0.002 | \n", "0.6779+/-0.0044 | \n", "0.716+/-0.0021 | \n", "0.6783+/-0.0044 | \n", "0.7156+/-0.0021 | \n", "0.6778+/-0.0044 | \n", "0.716+/-0.0021 | \n", "0.6783+/-0.0044 | \n", "0.3335 | \n", "
| RFC | \n", "0.7949+/-0.0004 | \n", "0.7137+/-0.0033 | \n", "0.7954+/-0.0004 | \n", "0.7143+/-0.0033 | \n", "0.7954+/-0.0004 | \n", "0.7138+/-0.0033 | \n", "0.7954+/-0.0004 | \n", "0.7143+/-0.0033 | \n", "22.1765 | \n", "
| NB | \n", "0.6143+/-0.0009 | \n", "0.614+/-0.0045 | \n", "0.6295+/-0.0008 | \n", "0.6292+/-0.0043 | \n", "0.6352+/-0.0009 | \n", "0.635+/-0.0051 | \n", "0.6295+/-0.0008 | \n", "0.6292+/-0.0043 | \n", "0.0959 | \n", "
| GBC | \n", "0.6434+/-0.001 | \n", "0.6419+/-0.0041 | \n", "0.6512+/-0.0009 | \n", "0.6497+/-0.0041 | \n", "0.6533+/-0.0009 | \n", "0.6518+/-0.0045 | \n", "0.6512+/-0.0009 | \n", "0.6497+/-0.0041 | \n", "8.1768 | \n", "
| ABC | \n", "0.6554+/-0.0014 | \n", "0.6524+/-0.0029 | \n", "0.661+/-0.0013 | \n", "0.6581+/-0.0027 | \n", "0.6622+/-0.0013 | \n", "0.6592+/-0.0029 | \n", "0.661+/-0.0013 | \n", "0.6581+/-0.0027 | \n", "10.246 | \n", "
| SVC | \n", "0.6111+/-0.0008 | \n", "0.6111+/-0.0047 | \n", "0.628+/-0.0007 | \n", "0.628+/-0.0044 | \n", "0.635+/-0.0009 | \n", "0.635+/-0.0052 | \n", "0.628+/-0.0007 | \n", "0.628+/-0.0044 | \n", "908.9923 | \n", "
| MLP | \n", "0.6331+/-0.0024 | \n", "0.6299+/-0.0055 | \n", "0.6425+/-0.0019 | \n", "0.6395+/-0.0049 | \n", "0.6452+/-0.0027 | \n", "0.6421+/-0.0056 | \n", "0.6425+/-0.0019 | \n", "0.6395+/-0.0049 | \n", "553.7521 | \n", "
| \n", " | F1 Train | \n", "F1 Validation | \n", "Recall Train | \n", "Recall Validation | \n", "Precision Train | \n", "Precision Validation | \n", "Accuracy Train | \n", "Accuracy Validation | \n", "Running Time | \n", "
|---|---|---|---|---|---|---|---|---|---|
| Best KNN | \n", "0.7469+/-0.0006 | \n", "0.682+/-0.0041 | \n", "0.7468+/-0.0006 | \n", "0.6818+/-0.0041 | \n", "0.7535+/-0.0007 | \n", "0.6881+/-0.004 | \n", "0.7468+/-0.0006 | \n", "0.6818+/-0.0041 | \n", "25.3655 | \n", "
| Best DT | \n", "0.735+/-0.0032 | \n", "0.6861+/-0.0043 | \n", "0.7361+/-0.0031 | \n", "0.6873+/-0.0042 | \n", "0.7359+/-0.003 | \n", "0.6866+/-0.0042 | \n", "0.7361+/-0.0031 | \n", "0.6873+/-0.0042 | \n", "0.4926 | \n", "
| Best RFC | \n", "0.8004+/-0.0007 | \n", "0.7202+/-0.0032 | \n", "0.8012+/-0.0008 | \n", "0.7213+/-0.0031 | \n", "0.8018+/-0.0008 | \n", "0.7209+/-0.0032 | \n", "0.8012+/-0.0008 | \n", "0.7213+/-0.0031 | \n", "14.5572 | \n", "
| label | \n", "0 | \n", "1 | \n", "2 | \n", "
|---|---|---|---|
| sold | \n", "0.606257 | \n", "0.632925 | \n", "0.322645 | \n", "
| type_Medium | \n", "0.060445 | \n", "0.708554 | \n", "0.472006 | \n", "
| type_Small | \n", "0.939044 | \n", "0.000000 | \n", "0.291538 | \n", "
| marca_2_yes | \n", "0.978063 | \n", "0.989929 | \n", "0.000905 | \n", "
| unique_skus_brand | \n", "120.664423 | \n", "122.023158 | \n", "14.205349 | \n", "
| product_cost | \n", "0.825345 | \n", "0.857962 | \n", "1.123977 | \n", "
| perc_expiring_sku | \n", "0.361906 | \n", "0.377179 | \n", "0.424813 | \n", "
| selling_square_ft | \n", "1076.125128 | \n", "9096.905509 | \n", "6858.341139 | \n", "